import os,pymssql
#
server="127.0.0.1"
user="sa"
password="abc123@"

conn=pymssql.connect( server=server, port=2014, user= user,password = password,database="master")
cursor=conn.cursor()
cursor.execute("""select getdate()""")
row=cursor.fetchone()
while row:
    print("sqlserver version:%s"%(row[0]))
    row=cursor.fetchone()

conn.close()

# import pymssql
#
# # server    数据库服务器名称或IP
# # user      用户名
# # password  密码
# # database  数据库名称
# conn = pymssql.connect(server, user, password, database="master")
#
# cursor = conn.cursor()
#
# # 新建、插入操作
# cursor.execute("""
# IF OBJECT_ID('persons', 'U') IS NOT NULL
#     DROP TABLE persons
# CREATE TABLE persons (
#     id INT NOT NULL,
#     name VARCHAR(100),
#     salesrep VARCHAR(100),
#     PRIMARY KEY(id)
# )
# """)
# cursor.executemany(
#     "INSERT INTO persons VALUES (%d, %s, %s)",
#     [(1, 'John Smith', 'John Doe'),
#      (2, 'Jane Doe', 'Joe Dog'),
#      (3, 'Mike T.', 'Sarah H.')])
# # 如果没有指定autocommit属性为True的话就需要调用commit()方法
# conn.commit()
#
# # 查询操作
# cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
# row = cursor.fetchone()
# while row:
#     print("ID=%d, Name=%s" % (row[0], row[1]))
#     row = cursor.fetchone()
#
# # 也可以使用for循环来迭代查询结果
# # for row in cursor:
# #     print("ID=%d, Name=%s" % (row[0], row[1]))
#
# # 关闭连接
# conn.close()